Introduction to SQL MCQs
Practice free Introduction to SQL multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 73 questions — no login required.
Question 55easy
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
Question 57easy
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
Advertisement
Question 59easy
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
Question 60easy
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
Advertisement
Question 61easy
The keyword LIKE can be used in a WHERE clause to refer to a range of values.
Question 62easy
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
Question 63easy
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.